1 Moves in Unfunded Liabiities from 2020-2021

1.1 By Entity

Moves in Unfunded Liabilities from 2020-2021

1.1.0.1 Figure 1:Total Unfunded Liabilities by Entity from 2020-2022

1.1.0.1.1 Figure 2:Rate of Change in Unfunded Liabilities by Entity from 2020-2022

Combined Change Data Arranged by Dataset
Dataset year TotalOPEB TotalNPL
City 2020 $156,522,239,133 $178,384,996,141
City 2021 $165,964,671,391 $141,260,147,751
City 2022 $130,905,745,444 $146,684,931,141
County 2020 $88,139,766,353 $114,549,691,913
County 2021 $92,114,983,017 $111,537,178,855
County 2022 $81,544,557,919 $77,814,734,484
SD 2020 $52,290,428,798 $78,463,359,078
SD 2021 $55,873,428,067 $87,451,369,176
SD 2022 $52,705,920,347 $51,649,985,324
State 2020 $524,909,940,837 $684,637,601,415
State 2021 $574,807,219,450 $743,184,295,659
State 2022 $528,409,889,023 $520,513,990,453
Changes in Total OPEB Unfunded Liabilities 2020-2022 by Entity
Entity NPL Change NPL Percent Change Net OPEB Change OPEB Percent Change
State -$164,123,610,962 -24.0% $3,499,948,186 0.67%
SD -$26,813,373,754 -34.2% $415,491,549 0.79%
City -$31,700,065,000 -17.8% -$25,616,493,689 -16.37%
County -$36,734,957,429 -32.1% -$6,595,208,434 -7.48%

1.2 By Population

Moves in Unfunded Liabiities from 2020-2021

1.2.0.1 Cities

1.2.0.1.1 Figure 3:Correlation between Population and Unfunded Liabilities in 2020 - 2022
## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 2 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 2 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 2 rows containing missing values (`geom_point()`).
States: Correlation Between % Difference in NPL Population

States: Correlation Between % Difference in NPL Population 

## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 2 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 2 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 2 rows containing missing values (`geom_point()`).
Cities: Correlation Between % Difference in NPL Population

Cities: Correlation Between % Difference in NPL Population 

## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 5 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 5 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 3 rows containing missing values (`geom_point()`).
Counties: Correlation Between % Difference in NPL Population

Counties: Correlation Between % Difference in NPL Population 

## `geom_smooth()` using formula = 'y ~ x'
## Warning: Removed 10 rows containing non-finite values (`stat_smooth()`).
## Warning: Removed 10 rows containing non-finite values (`stat_cor()`).
## Warning: Removed 10 rows containing missing values (`geom_point()`).
School Districts: Correlation Between % Difference in NPL Population

School Districts: Correlation Between % Difference in NPL Population

Total Unfunded Liabilities 2020-2022 - Cities divided by Population Quartiles

Total Unfunded Liabilities 2020-2022 - Cities divided by Population Quartiles

Population Ranges of Each City Quartile (2022)
Quartile Min Max
1 208,640 259,520
2 263,914 383,998
3 384,661 631,539
4 639,115 8,804,194
1.2.0.1.2 Figure 4:Total Unfunded Liabilities 2020-2022 - Cities divided by Population Quartiles
Changes in City Unfunded Liabilities by Population Quartiles
Year Pop Quartile Total NPL % Change from Previous Year $ Change from Previous Year
2021 1 $5,228,004,831 -3% -$137,372,891
2022 1 $3,224,089,824 -38% -$2,003,915,007
2021 2 $9,216,231,780 -14% -$1,553,009,578
2022 2 $6,740,056,661 -27% -$2,476,175,119
2021 3 $18,077,273,298 0% -$7,913,508
2022 3 $13,913,327,591 -23% -$4,163,945,707
2021 4 $108,738,637,842 -25% -$35,426,552,413
2022 4 $122,807,457,065 13% $14,068,819,223

1.3 Correlations

1.3.1 States

1.3.2 Cities

1.3.3 Counties

1.3.4 School Districts

1.4 OPEB

1.4.1 What happened from 2020 to 2022?

Changes in Total OPEB Unfunded Liabilities 2020-2022 by Entity
Entity Year Net OPEB Change OPEB Percent Change
State 2022 $3,499,948,186 0.67%
SD 2022 $415,491,549 0.79%
City 2022 -$25,616,493,689 -16.37%
County 2022 -$6,595,208,434 -7.48%

1.4.2 States

Changes in State OPEB Unfunded Liabilities 2020-2022
Year Net OPEB Change OPEB Percent Change
2020 $3,499,948,186 1%
2021 $3,499,948,186 1%
2022 $3,499,948,186 1%

1.4.3 Cities

1.4.4 School Districs

1.4.5 Counties

2 The Governmental Units

2.1 States

State Total Net Pension Liability
2020 $684,637,601,415.00 NA
2021 $743,184,295,659.00 8.55%
2022 $520,513,990,453.00 -29.96%

2.1.1 The States in 2022

2.1.2 Top 10 States by Liabilities 2022

State Net Pension Liability Per Capita
Illinois $139,846,000,000 $10,914.77
New Jersey $75,075,280,124 $8,082.14
California $54,169,128,000 $1,370.04
Connecticut $36,132,877,000 $10,020.37
Massachusetts $34,806,645,000 $4,951.19
Texas $30,883,865,000 $1,059.65
Kentucky $25,034,578,000 $5,555.96
Maryland $13,366,859,000 $2,163.90
Pennsylvania $12,550,399,000 $965.22
Indiana $9,781,677,000 $1,441.52

2.1.3 Top 10 States by Per Capita Liabilities 2022

State Per Capita NPL Total NPL
Illinois $10,914.77 $139,846,000,000
Connecticut $10,020.37 $36,132,877,000
New Jersey $8,082.14 $75,075,280,124
Kentucky $5,555.96 $25,034,578,000
Massachusetts $4,951.19 $34,806,645,000
Hawaii $4,345.08 $6,323,283,000
Vermont $3,906.27 $2,512,066,064
Alaska $3,253.06 $2,385,726,000
Rhode Island $2,585.82 $2,837,608,000
New Mexico $2,373.82 $5,026,620,000

2.2 Cities

State Total Net Pension Liability
2020 $178,384,996,141.00 NA
2021 $141,260,147,751.00 -20.81%
2022 $146,684,931,141.00 3.84%

2.2.1 The Cities in 2022

2.2.2 Top 10 Cities by Liabilities 2022

City State Net Pension Liability Per Capita
new york NY $42,349,466,000 $4,810.15
chicago IL $35,436,606,000 $12,903.16
philadelphia PA $5,386,419,000 $3,358.54
phoenix AZ $4,643,155,000 $2,887.19
los angeles CA $4,363,649,000 $1,119.24
portland OR $4,275,718,773 $6,552.64
dallas TX $4,029,247,000 $3,089.16
jacksonville FL $2,905,810,000 $3,059.98
san jose CA $2,342,879,000 $2,312.31
houston TX $2,322,472,000 $1,009.08

2.2.2.1 Top 10 Cities by Per Capita Liabilities 2022

City State Per Capita NPL Total NPL
chicago IL $12,903.16 $35,436,606,000
portland OR $6,552.64 $4,275,718,773
new york NY $4,810.15 $42,349,466,000
philadelphia PA $3,358.54 $5,386,419,000
dallas TX $3,089.16 $4,029,247,000
cincinnati OH $3,086.75 $955,536,000
jacksonville FL $3,059.98 $2,905,810,000
pittsburgh PA $3,050.90 $924,293,454
miami FL $2,942.66 $1,301,418,710
phoenix AZ $2,887.19 $4,643,155,000

2.3 Counties

State Total Net Pension Liability
2020 $114,549,691,913.00 NA
2021 $111,537,178,855.00 -2.63%
2022 $77,814,734,484.00 -30.23%

2.3.0.1 The Counties in 2022

2.3.1 Top 10 Counties by Net Pension Liabilities 2022

County State Net Pension Liability Per Capita
cook county IL $10,837,262,892 $2,054.25
los angeles county CA $7,030,463,000 $702.06
philadelphia PA $5,386,419,000 $3,358.54
miami-dade county FL $3,979,267,000 $1,472.84
santa clara county CA $2,989,893,000 $1,544.15
jacksonville FL $2,905,810,000 $2,918.77
city and county of honolulu HI $2,270,106,000 $2,233.24
san diego county CA $2,246,673,000 $681.09
orange county CA $2,048,680,000 $642.83
prince georges county MD $2,011,969,036 $2,080.21

2.3.2 Top 10 County by Per Capita Liabilities in 2022

County State Per Capita Total NPL
philadelphia PA $3,358.54 $5,386,419,000
jacksonville FL $2,918.77 $2,905,810,000
city and county of honolulu HI $2,233.24 $2,270,106,000
prince georges county MD $2,080.21 $2,011,969,036
cook county IL $2,054.25 $10,837,262,892
denver county CO $2,032.63 $1,454,425,000
baltimore county MD $1,863.20 $1,592,201,000
santa clara county CA $1,544.15 $2,989,893,000
kern county CA $1,541.70 $1,401,786,000
dekalb county GA $1,531.02 $1,170,291,000

2.4 School Districts

State Total Net Pension Liability
2020 $78,463,359,078.00 NA
2021 $87,451,369,176.00 11.46%
2022 $51,649,985,324.00 -40.94%

2.4.1 The School Districts in 2022

2.4.2 Top 10 School Districts by Liabilities 2022

County State Net Pension Liability Per Student
Chicago Board of Education IL $14,727,410,000 $42,382.99
Los Angeles Unified School District CA $4,311,675,000 $8,922.54
School District of Philadelphia PA $3,253,100,000 $24,905.64
Clark County School District NV $2,167,406,738 $6,588.04
Fairfax County Public Schools VA $2,163,904,859 $11,456.08
Albuquerque Municipal School District No. 12 NM $1,208,673,186 $13,686.40
Jefferson County School District No R-1 CO $1,032,420,784 $12,279.32
The School Board of Miami-Dade County FL $979,938,000 $2,821.53
The School District of Greenville County SC $860,615,385 $11,133.16
Cherry Creek School District No 5 CO $845,137,624 $15,030.55

2.4.3 Top 10 School Districts by Per Student Liabilities in 2022

County State Net Pension Liability Per Student
Chicago Board of Education IL $14,727,410,000 $42,382.99
Los Angeles Unified School District CA $4,311,675,000 $8,922.54
School District of Philadelphia PA $3,253,100,000 $24,905.64
Clark County School District NV $2,167,406,738 $6,588.04
Fairfax County Public Schools VA $2,163,904,859 $11,456.08
Albuquerque Municipal School District No. 12 NM $1,208,673,186 $13,686.40
Jefferson County School District No R-1 CO $1,032,420,784 $12,279.32
The School Board of Miami-Dade County FL $979,938,000 $2,821.53
The School District of Greenville County SC $860,615,385 $11,133.16
Cherry Creek School District No 5 CO $845,137,624 $15,030.55